load data
characterset  UTF8 
--infile ''
append into table I_AAA_CUSTOMER1
fields terminated by X'09' --一个tab，分隔符
TRAILING NULLCOLS (
	USERNAME,
	SERVICETYPE,
	AREANO,
	PAYTYPE,
	GROUPID,
	NASIP,
	BINDTYPE,
	BINDATTR,
	LIMITUSERS,
	STATUS,
	OPENDATE DATE 'YYYY-MM-DD HH24:MI:SS',
	EFFECTDATE DATE 'YYYY-MM-DD HH24:MI:SS',
	EXPIREDATE DATE 'YYYY-MM-DD HH24:MI:SS',
	CLOSEDATE date 'YYYY-MM-DD HH24:MI:SS',
	BANDWIDTH,
	BILLINGDATE	DATE 'YYYY-MM-DD HH24:MI:SS',
	ROAMLEVEL,
	OPTIONALSERVICE,
	UPBANDWIDTH,
	BATCHTIMESTAMP EXPRESSION "TO_DATE('2013-11-11 11:11:11','YYYY-MM-DD HH24:MI:SS')",
	ID "SEQ_I_AAA_CUSTOMER.NEXTVAL"  --使用序列，序列放在最后一列进行自动添加
)

--sqlldr userid=obasdev/obasdev@DB control='D:\repository\workspaces\googlecode_obas_java\com.obas.network.java.impl\src\com\obas\integration\aaa\service\impl\aaa.customer.ctl' data='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\user_info_201305132035.txt' log='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\user_info.log' parallel=true rows=5000 bindsize=10485760
